Space Manager: slave idle wait
Idle event. Oracle In memory option space management process (Wnnn) is waiting to be allocated work.
Disclaimer​
The terms master and slave have historically been used by vendors in database wait events. DBmarlin does not support or condone the use of these terms. As vendors remove these terms from their software, occurrences will reduce.
Detailed Description​
Both the The Space Management Coordinator (SMCO) and the In Memory Coordinator (IMCO) use Space Management Worker Processes (Wnnn) perform various background space management tasks, including proactive space allocation and reclamation from dropped objects.
This IDLE wait is shown when the process is waiting to be allocated work.
How to reduce this wait​
This is an IDLE wait and not normally a concern as it indicates the process is inactive and is waiting to be given work to do. After being spawned, the Wnnn processes run autonomously until they complete their task, and then wait to be allocated another task. The Wnnn process will exit and have to be respawned if it stays idle too long.
Additional Links​
Oracle Reference - Background processes (IMCO, SMCO and Wnnn)
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.